Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 69958 |
| Missing cells | 236314 |
| Missing cells (%) | 14.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 12.8 MiB |
| Average record size in memory | 192.0 B |
Variable types
| Text | 3 |
|---|---|
| Categorical | 8 |
| Numeric | 10 |
| DateTime | 3 |
ACCOUNT_TYPE is highly overall correlated with OWNERSHIP_TYPE | High correlation |
ACTUAL_PAYMT_AMT is highly overall correlated with AMOUNT_OVERDUE and 4 other fields | High correlation |
ACTUAL_ROI is highly overall correlated with CURRENT_BALANCE and 2 other fields | High correlation |
AMOUNT_OVERDUE is highly overall correlated with ACTUAL_PAYMT_AMT and 4 other fields | High correlation |
COLLATERALVALUE is highly overall correlated with ACTUAL_PAYMT_AMT and 3 other fields | High correlation |
CURRENT_BALANCE is highly overall correlated with ACTUAL_PAYMT_AMT and 6 other fields | High correlation |
DATE_REPORTED_AND_CERTIFIED is highly overall correlated with OCCUPATION_TYPE and 2 other fields | High correlation |
EMI_AMOUNT is highly overall correlated with ACTUAL_PAYMT_AMT and 4 other fields | High correlation |
HIGH_CREDIT_OR_SANCTIONED_AMOUNT is highly overall correlated with ACTUAL_PAYMT_AMT and 5 other fields | High correlation |
LOAN_CLASSIFICATION is highly overall correlated with AMOUNT_OVERDUE and 1 other fields | High correlation |
OCCUPATION_TYPE is highly overall correlated with DATE_REPORTED_AND_CERTIFIED and 3 other fields | High correlation |
OWNERSHIP_TYPE is highly overall correlated with ACCOUNT_TYPE and 3 other fields | High correlation |
PAYMENT_HISTORY_END_DATE is highly overall correlated with OWNERSHIP_TYPE | High correlation |
PAYMENT_HISTORY_START_DATE is highly overall correlated with DATE_REPORTED_AND_CERTIFIED and 2 other fields | High correlation |
REPAYMENT_TENURE is highly overall correlated with CURRENT_BALANCE | High correlation |
Reported_Date is highly overall correlated with DATE_REPORTED_AND_CERTIFIED and 2 other fields | High correlation |
TU_SCORE is highly overall correlated with LOAN_CLASSIFICATION | High correlation |
PAYMENT_HISTORY_START_DATE is highly imbalanced (> 99.9%) | Imbalance |
DATE_REPORTED_AND_CERTIFIED is highly imbalanced (> 99.9%) | Imbalance |
Reported_Date is highly imbalanced (> 99.9%) | Imbalance |
ACTUAL_PAYMT_AMT has 4217 (6.0%) missing values | Missing |
EMI_AMOUNT has 49766 (71.1%) missing values | Missing |
REPAYMENT_TENURE has 37176 (53.1%) missing values | Missing |
AMOUNT_OVERDUE has 60089 (85.9%) missing values | Missing |
PAYMENT_HISTORY_2 has 39673 (56.7%) missing values | Missing |
COLLATERALVALUE has 22968 (32.8%) missing values | Missing |
DATE_OF_LAST_PAYMENT has 3312 (4.7%) missing values | Missing |
OCCUPATION_TYPE has 19113 (27.3%) missing values | Missing |
HIGH_CREDIT_OR_SANCTIONED_AMOUNT is highly skewed (γ1 = 70.97189492) | Skewed |
CURRENT_BALANCE is highly skewed (γ1 = 78.0388996) | Skewed |
ACTUAL_PAYMT_AMT is highly skewed (γ1 = 112.6517969) | Skewed |
EMI_AMOUNT is highly skewed (γ1 = 35.71864192) | Skewed |
AMOUNT_OVERDUE is highly skewed (γ1 = 58.2778575) | Skewed |
COLLATERALVALUE is highly skewed (γ1 = 39.33065288) | Skewed |
ID has unique values | Unique |
LOAN_CLASSIFICATION has 60089 (85.9%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-03 07:21:44.942725 |
|---|---|
| Analysis finished | 2024-03-03 07:22:45.655556 |
| Duration | 1 minute and 0.71 seconds |
| Software version | ydata-profiling vv4.6.5 |
| Download configuration | config.json |
ID
Text
UNIQUE
| Distinct | 69958 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 10.089125 |
| Min length | 10 |
Characters and Unicode
| Total characters | 705815 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 69958 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | A002338349 |
|---|---|
| 2nd row | A002000537 |
| 3rd row | A002421579 |
| 4th row | A002152345 |
| 5th row | A001952834 |
| Value | Count | Frequency (%) |
| a002338349 | 1 | < 0.1% |
| a001137499 | 1 | < 0.1% |
| b000113967 | 1 | < 0.1% |
| a001558607 | 1 | < 0.1% |
| a000155334 | 1 | < 0.1% |
| a001091986 | 1 | < 0.1% |
| a001132923 | 1 | < 0.1% |
| a002421104 | 1 | < 0.1% |
| a000936177 | 1 | < 0.1% |
| a002232156 | 1 | < 0.1% |
| Other values (69948) | 69948 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 218836 | |
| 1 | 72906 | 10.3% |
| A | 55027 | 7.8% |
| 2 | 54033 | 7.7% |
| 3 | 44719 | 6.3% |
| 4 | 42499 | 6.0% |
| 6 | 40396 | 5.7% |
| 8 | 39626 | 5.6% |
| 5 | 39623 | 5.6% |
| 7 | 39556 | 5.6% |
| Other values (11) | 58594 | 8.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 631543 | |
| Uppercase Letter | 71974 | 10.2% |
| Connector Punctuation | 2298 | 0.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 218836 | |
| 1 | 72906 | 11.5% |
| 2 | 54033 | 8.6% |
| 3 | 44719 | 7.1% |
| 4 | 42499 | 6.7% |
| 6 | 40396 | 6.4% |
| 8 | 39626 | 6.3% |
| 5 | 39623 | 6.3% |
| 7 | 39556 | 6.3% |
| 9 | 39349 | 6.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 55027 | |
| B | 10699 | 14.9% |
| J | 2016 | 2.8% |
| K | 2016 | 2.8% |
| D | 1911 | 2.7% |
| E | 126 | 0.2% |
| H | 68 | 0.1% |
| C | 60 | 0.1% |
| F | 49 | 0.1% |
| G | 2 | < 0.1% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 2298 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 633841 | |
| Latin | 71974 | 10.2% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 218836 | |
| 1 | 72906 | 11.5% |
| 2 | 54033 | 8.5% |
| 3 | 44719 | 7.1% |
| 4 | 42499 | 6.7% |
| 6 | 40396 | 6.4% |
| 8 | 39626 | 6.3% |
| 5 | 39623 | 6.3% |
| 7 | 39556 | 6.2% |
| 9 | 39349 | 6.2% |
Latin
| Value | Count | Frequency (%) |
| A | 55027 | |
| B | 10699 | 14.9% |
| J | 2016 | 2.8% |
| K | 2016 | 2.8% |
| D | 1911 | 2.7% |
| E | 126 | 0.2% |
| H | 68 | 0.1% |
| C | 60 | 0.1% |
| F | 49 | 0.1% |
| G | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 705815 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 218836 | |
| 1 | 72906 | 10.3% |
| A | 55027 | 7.8% |
| 2 | 54033 | 7.7% |
| 3 | 44719 | 6.3% |
| 4 | 42499 | 6.0% |
| 6 | 40396 | 5.7% |
| 8 | 39626 | 5.6% |
| 5 | 39623 | 5.6% |
| 7 | 39556 | 5.6% |
| Other values (11) | 58594 | 8.3% |
ACCOUNT_TYPE
Categorical
HIGH CORRELATION
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
| Housing Loan | |
|---|---|
| Personal Loan | |
| Property Loan | |
| Business Loan |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 12.483504 |
| Min length | 12 |
Characters and Unicode
| Total characters | 873321 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Housing Loan |
|---|---|
| 2nd row | Housing Loan |
| 3rd row | Housing Loan |
| 4th row | Housing Loan |
| 5th row | Housing Loan |
Common Values
| Value | Count | Frequency (%) |
| Housing Loan | 36133 | |
| Personal Loan | 15704 | |
| Property Loan | 10857 | 15.5% |
| Business Loan | 7264 | 10.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| loan | 69958 | |
| housing | 36133 | |
| personal | 15704 | 11.2% |
| property | 10857 | 7.8% |
| business | 7264 | 5.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 132652 | |
| n | 129059 | |
| a | 85662 | |
| s | 73629 | |
| 69958 | ||
| L | 69958 | |
| u | 43397 | 5.0% |
| i | 43397 | 5.0% |
| r | 37418 | 4.3% |
| H | 36133 | 4.1% |
| Other values (8) | 152058 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 663447 | |
| Uppercase Letter | 139916 | 16.0% |
| Space Separator | 69958 | 8.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 132652 | |
| n | 129059 | |
| a | 85662 | |
| s | 73629 | |
| u | 43397 | 6.5% |
| i | 43397 | 6.5% |
| r | 37418 | 5.6% |
| g | 36133 | 5.4% |
| e | 33825 | 5.1% |
| l | 15704 | 2.4% |
| Other values (3) | 32571 | 4.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 69958 | |
| H | 36133 | |
| P | 26561 | 19.0% |
| B | 7264 | 5.2% |
Space Separator
| Value | Count | Frequency (%) |
| 69958 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 803363 | |
| Common | 69958 | 8.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 132652 | |
| n | 129059 | |
| a | 85662 | |
| s | 73629 | |
| L | 69958 | |
| u | 43397 | 5.4% |
| i | 43397 | 5.4% |
| r | 37418 | 4.7% |
| H | 36133 | 4.5% |
| g | 36133 | 4.5% |
| Other values (7) | 115925 |
Common
| Value | Count | Frequency (%) |
| 69958 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 873321 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 132652 | |
| n | 129059 | |
| a | 85662 | |
| s | 73629 | |
| 69958 | ||
| L | 69958 | |
| u | 43397 | 5.0% |
| i | 43397 | 5.0% |
| r | 37418 | 4.3% |
| H | 36133 | 4.1% |
| Other values (8) | 152058 |
HIGH_CREDIT_OR_SANCTIONED_AMOUNT
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 48767 |
|---|---|
| Distinct (%) | 69.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1354749.4 |
| Minimum | 4282 |
|---|---|
| Maximum | 5.4 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 546.7 KiB |
Quantile statistics
| Minimum | 4282 |
|---|---|
| 5-th percentile | 25000 |
| Q1 | 364466.5 |
| median | 939368.5 |
| Q3 | 1578010.5 |
| 95-th percentile | 3795019.3 |
| Maximum | 5.4 × 108 |
| Range | 5.3999572 × 108 |
| Interquartile range (IQR) | 1213544 |
Descriptive statistics
| Standard deviation | 3656262.8 |
|---|---|
| Coefficient of variation (CV) | 2.6988481 |
| Kurtosis | 8381.8407 |
| Mean | 1354749.4 |
| Median Absolute Deviation (MAD) | 614155.5 |
| Skewness | 70.971895 |
| Sum | 9.4775558 × 1010 |
| Variance | 1.3368257 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 50000 | 848 | 1.2% |
| 20000 | 794 | 1.1% |
| 25000 | 641 | 0.9% |
| 100000 | 570 | 0.8% |
| 30000 | 559 | 0.8% |
| 300000 | 552 | 0.8% |
| 14400 | 502 | 0.7% |
| 40000 | 417 | 0.6% |
| 500000 | 408 | 0.6% |
| 200000 | 359 | 0.5% |
| Other values (48757) | 64308 |
| Value | Count | Frequency (%) |
| 4282 | 1 | < 0.1% |
| 4362 | 1 | < 0.1% |
| 5000 | 102 | |
| 5412 | 1 | < 0.1% |
| 6165 | 1 | < 0.1% |
| 6230 | 1 | < 0.1% |
| 6684 | 1 | < 0.1% |
| 7000 | 50 | |
| 7739 | 1 | < 0.1% |
| 7751 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 540000000 | 1 | |
| 300000000 | 1 | |
| 272500000 | 1 | |
| 253922969 | 1 | |
| 215000000 | 1 | |
| 140486389 | 1 | |
| 116018923 | 1 | |
| 114999999 | 1 | |
| 99964530 | 1 | |
| 74099999 | 1 |
DATE_OPENED
Date
| Distinct | 4554 |
|---|---|
| Distinct (%) | 6.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
| Minimum | 2002-05-23 00:00:00 |
|---|---|
| Maximum | 2023-12-11 00:00:00 |
Histogram with fixed size bins (bins=50)
CURRENT_BALANCE
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 64261 |
|---|---|
| Distinct (%) | 91.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1131129.2 |
| Minimum | 1067 |
|---|---|
| Maximum | 5.1756481 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 546.7 KiB |
Quantile statistics
| Minimum | 1067 |
|---|---|
| 5-th percentile | 18036.85 |
| Q1 | 228626.5 |
| median | 705422.5 |
| Q3 | 1331960 |
| 95-th percentile | 3419083.6 |
| Maximum | 5.1756481 × 108 |
| Range | 5.1756375 × 108 |
| Interquartile range (IQR) | 1103333.5 |
Descriptive statistics
| Standard deviation | 3398279.9 |
|---|---|
| Coefficient of variation (CV) | 3.0043251 |
| Kurtosis | 9621.9409 |
| Mean | 1131129.2 |
| Median Absolute Deviation (MAD) | 524175 |
| Skewness | 78.0389 |
| Sum | 7.9131538 × 1010 |
| Variance | 1.1548306 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 25000 | 226 | 0.3% |
| 20000 | 213 | 0.3% |
| 14400 | 180 | 0.3% |
| 11585 | 169 | 0.2% |
| 8738 | 146 | 0.2% |
| 50000 | 131 | 0.2% |
| 10000 | 126 | 0.2% |
| 35000 | 123 | 0.2% |
| 16761 | 117 | 0.2% |
| 45000 | 112 | 0.2% |
| Other values (64251) | 68415 |
| Value | Count | Frequency (%) |
| 1067 | 1 | |
| 1129 | 1 | |
| 1214 | 1 | |
| 1334 | 1 | |
| 1522 | 1 | |
| 1649 | 1 | |
| 1740 | 1 | |
| 1757 | 1 | |
| 1836 | 1 | |
| 1839 | 1 |
| Value | Count | Frequency (%) |
| 517564813 | 1 | |
| 295884568 | 1 | |
| 276506532 | 1 | |
| 235061727 | 1 | |
| 207133491 | 1 | |
| 112981953 | 1 | |
| 104874827 | 1 | |
| 103162557 | 1 | |
| 63777411 | 1 | |
| 62576118 | 1 |
ACTUAL_PAYMT_AMT
Real number (ℝ)
HIGH CORRELATION MISSING SKEWED
| Distinct | 27311 |
|---|---|
| Distinct (%) | 41.5% |
| Missing | 4217 |
| Missing (%) | 6.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16407.994 |
| Minimum | 1 |
|---|---|
| Maximum | 13485322 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 546.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 500 |
| Q1 | 4433 |
| median | 10374 |
| Q3 | 18294 |
| 95-th percentile | 40765 |
| Maximum | 13485322 |
| Range | 13485321 |
| Interquartile range (IQR) | 13861 |
Descriptive statistics
| Standard deviation | 72253.913 |
|---|---|
| Coefficient of variation (CV) | 4.4035798 |
| Kurtosis | 19087.909 |
| Mean | 16407.994 |
| Median Absolute Deviation (MAD) | 6586 |
| Skewness | 112.6518 |
| Sum | 1.078678 × 109 |
| Variance | 5.2206279 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 500 | 3199 | 4.6% |
| 3000 | 417 | 0.6% |
| 1000 | 395 | 0.6% |
| 1180 | 376 | 0.5% |
| 2980 | 330 | 0.5% |
| 2360 | 183 | 0.3% |
| 1770 | 176 | 0.3% |
| 590 | 137 | 0.2% |
| 3469 | 112 | 0.2% |
| 3788 | 109 | 0.2% |
| Other values (27301) | 60307 | |
| (Missing) | 4217 | 6.0% |
| Value | Count | Frequency (%) |
| 1 | 24 | |
| 2 | 13 | |
| 3 | 6 | < 0.1% |
| 4 | 6 | < 0.1% |
| 5 | 4 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 8 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 13485322 | 1 | |
| 5350961 | 1 | |
| 3701180 | 1 | |
| 3316197 | 1 | |
| 2600000 | 1 | |
| 2363270 | 1 | |
| 2052500 | 1 | |
| 1730000 | 1 | |
| 1700000 | 1 | |
| 1672474 | 1 |
EMI_AMOUNT
Real number (ℝ)
HIGH CORRELATION MISSING SKEWED
| Distinct | 14364 |
|---|---|
| Distinct (%) | 71.1% |
| Missing | 49766 |
| Missing (%) | 71.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18721.456 |
| Minimum | 15 |
|---|---|
| Maximum | 3700000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 546.7 KiB |
Quantile statistics
| Minimum | 15 |
|---|---|
| 5-th percentile | 2077 |
| Q1 | 6477.5 |
| median | 12005.5 |
| Q3 | 19913 |
| 95-th percentile | 43406.35 |
| Maximum | 3700000 |
| Range | 3699985 |
| Interquartile range (IQR) | 13435.5 |
Descriptive statistics
| Standard deviation | 61515.261 |
|---|---|
| Coefficient of variation (CV) | 3.285816 |
| Kurtosis | 1723.0905 |
| Mean | 18721.456 |
| Median Absolute Deviation (MAD) | 6269.5 |
| Skewness | 35.718642 |
| Sum | 3.7802364 × 108 |
| Variance | 3.7841273 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2980 | 93 | 0.1% |
| 3468 | 66 | 0.1% |
| 3788 | 52 | 0.1% |
| 163 | 28 | < 0.1% |
| 4630 | 16 | < 0.1% |
| 82 | 15 | < 0.1% |
| 100000 | 14 | < 0.1% |
| 10696 | 13 | < 0.1% |
| 841 | 13 | < 0.1% |
| 210 | 13 | < 0.1% |
| Other values (14354) | 19869 | 28.4% |
| (Missing) | 49766 |
| Value | Count | Frequency (%) |
| 15 | 2 | < 0.1% |
| 17 | 2 | < 0.1% |
| 20 | 1 | < 0.1% |
| 21 | 8 | |
| 28 | 4 | |
| 30 | 3 | < 0.1% |
| 33 | 3 | < 0.1% |
| 35 | 1 | < 0.1% |
| 36 | 2 | < 0.1% |
| 41 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3700000 | 1 | |
| 3316197 | 1 | |
| 3291763 | 1 | |
| 2537872 | 1 | |
| 1988087 | 1 | |
| 1700000 | 1 | |
| 1579911 | 1 | |
| 1327942 | 1 | |
| 1200000 | 1 | |
| 1155815 | 1 |
REPAYMENT_TENURE
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 539 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 37176 |
| Missing (%) | 53.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 165.99085 |
| Minimum | 10 |
|---|---|
| Maximum | 736 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 546.7 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 90 |
| median | 160 |
| Q3 | 233 |
| 95-th percentile | 325 |
| Maximum | 736 |
| Range | 726 |
| Interquartile range (IQR) | 143 |
Descriptive statistics
| Standard deviation | 93.270067 |
|---|---|
| Coefficient of variation (CV) | 0.56189885 |
| Kurtosis | 0.47146466 |
| Mean | 165.99085 |
| Median Absolute Deviation (MAD) | 71 |
| Skewness | 0.63847916 |
| Sum | 5441512 |
| Variance | 8699.3054 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 180 | 1483 | 2.1% |
| 48 | 1194 | 1.7% |
| 240 | 1006 | 1.4% |
| 120 | 428 | 0.6% |
| 36 | 401 | 0.6% |
| 300 | 398 | 0.6% |
| 251 | 367 | 0.5% |
| 222 | 356 | 0.5% |
| 260 | 306 | 0.4% |
| 259 | 229 | 0.3% |
| Other values (529) | 26614 | |
| (Missing) | 37176 |
| Value | Count | Frequency (%) |
| 10 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 17 | 23 | < 0.1% |
| 18 | 64 | |
| 19 | 41 | |
| 20 | 64 | |
| 21 | 52 | |
| 22 | 53 |
| Value | Count | Frequency (%) |
| 736 | 1 | |
| 704 | 2 | |
| 702 | 1 | |
| 692 | 1 | |
| 688 | 1 | |
| 644 | 1 | |
| 643 | 2 | |
| 640 | 1 | |
| 628 | 1 | |
| 624 | 1 |
LOAN_CLASSIFICATION
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 222 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.417036 |
| Minimum | 0 |
|---|---|
| Maximum | 900 |
| Zeros | 60089 |
| Zeros (%) | 85.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 546.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 90.15 |
| Maximum | 900 |
| Range | 900 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 134.43582 |
|---|---|
| Coefficient of variation (CV) | 4.569999 |
| Kurtosis | 31.784868 |
| Mean | 29.417036 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.6285548 |
| Sum | 2057957 |
| Variance | 18072.991 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 60089 | |
| 21 | 2225 | 3.2% |
| 900 | 1219 | 1.7% |
| 26 | 1198 | 1.7% |
| 52 | 1072 | 1.5% |
| 57 | 430 | 0.6% |
| 82 | 429 | 0.6% |
| 1 | 200 | 0.3% |
| 87 | 198 | 0.3% |
| 113 | 164 | 0.2% |
| Other values (212) | 2734 | 3.9% |
| Value | Count | Frequency (%) |
| 0 | 60089 | |
| 1 | 200 | 0.3% |
| 2 | 54 | 0.1% |
| 3 | 27 | < 0.1% |
| 4 | 17 | < 0.1% |
| 5 | 23 | < 0.1% |
| 6 | 14 | < 0.1% |
| 7 | 12 | < 0.1% |
| 8 | 12 | < 0.1% |
| 9 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 900 | 1219 | |
| 874 | 17 | < 0.1% |
| 843 | 24 | < 0.1% |
| 812 | 25 | < 0.1% |
| 782 | 31 | < 0.1% |
| 756 | 1 | < 0.1% |
| 751 | 33 | < 0.1% |
| 746 | 1 | < 0.1% |
| 726 | 3 | < 0.1% |
| 721 | 21 | < 0.1% |
AMOUNT_OVERDUE
Real number (ℝ)
HIGH CORRELATION MISSING SKEWED
| Distinct | 9139 |
|---|---|
| Distinct (%) | 92.6% |
| Missing | 60089 |
| Missing (%) | 85.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 364730.89 |
| Minimum | 1 |
|---|---|
| Maximum | 3.1050141 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 546.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1286 |
| Q1 | 10926 |
| median | 27500 |
| Q3 | 114104 |
| 95-th percentile | 1244236.8 |
| Maximum | 3.1050141 × 108 |
| Range | 3.1050141 × 108 |
| Interquartile range (IQR) | 103178 |
Descriptive statistics
| Standard deviation | 3912815.7 |
|---|---|
| Coefficient of variation (CV) | 10.727953 |
| Kurtosis | 4239.5977 |
| Mean | 364730.89 |
| Median Absolute Deviation (MAD) | 21904 |
| Skewness | 58.277857 |
| Sum | 3.5995292 × 109 |
| Variance | 1.5310127 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 95 | 0.1% |
| 2 | 19 | < 0.1% |
| 2980 | 11 | < 0.1% |
| 3467 | 7 | < 0.1% |
| 163 | 7 | < 0.1% |
| 5960 | 4 | < 0.1% |
| 3787 | 4 | < 0.1% |
| 4 | 4 | < 0.1% |
| 2437 | 4 | < 0.1% |
| 42 | 4 | < 0.1% |
| Other values (9129) | 9710 | 13.9% |
| (Missing) | 60089 |
| Value | Count | Frequency (%) |
| 1 | 95 | |
| 2 | 19 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 4 | < 0.1% |
| 5 | 2 | < 0.1% |
| 9 | 1 | < 0.1% |
| 12 | 1 | < 0.1% |
| 13 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 18 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 310501413 | 1 | |
| 145915781 | 1 | |
| 95509314 | 1 | |
| 53082500 | 1 | |
| 48790532 | 1 | |
| 45016680 | 1 | |
| 38052500 | 1 | |
| 31824969 | 1 | |
| 29272652 | 1 | |
| 27040270 | 1 |
| Distinct | 6173 |
|---|---|
| Distinct (%) | 8.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
Length
| Max length | 54 |
|---|---|
| Median length | 48 |
| Mean length | 25.195389 |
| Min length | 1 |
Characters and Unicode
| Total characters | 1762619 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5163 ? |
|---|---|
| Unique (%) | 7.4% |
Sample
| 1st row | 000000000000000000000000000000000000052052052021XXX000 |
|---|---|
| 2nd row | 000000000000000000000000000000000000000000000000XXX000 |
| 3rd row | 000000000000000000000000000000000000000000000000XXX000 |
| 4th row | 0 |
| 5th row | 539570570540509506507507507507509509509479478478XXX450 |
| Value | Count | Frequency (%) |
| 0 | 33791 | |
| 000000000000000000000000000000000000000000000000xxx000 | 17378 | |
| 000000000000000000000000000000000000000000000000xxxxxx | 2494 | 3.6% |
| 900900900900900900900900900900900900900900900900xxx900 | 702 | 1.0% |
| 000000000000000000000000000000000000xxx000000 | 538 | 0.8% |
| 000000000000000000000xxxxxxxxxxxxxxxxxxxxxxxx000xxx000 | 439 | 0.6% |
| 000000000000000000000000000000000000xxx000 | 361 | 0.5% |
| 021022021000000000000000000000000000000000000000xxx000 | 317 | 0.5% |
| 000000000000000000000000000000000000xxx000000000xxx000 | 307 | 0.4% |
| 000000000000000000000000000000000000000000000021xxx000 | 198 | 0.3% |
| Other values (6163) | 13433 | 19.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1437965 | |
| X | 124296 | 7.1% |
| 2 | 45378 | 2.6% |
| 5 | 28748 | 1.6% |
| 1 | 26663 | 1.5% |
| 9 | 22196 | 1.3% |
| 3 | 18165 | 1.0% |
| 8 | 14580 | 0.8% |
| 4 | 12336 | 0.7% |
| 7 | 12132 | 0.7% |
| Other values (4) | 20160 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1628831 | |
| Uppercase Letter | 127460 | 7.2% |
| Other Punctuation | 3164 | 0.2% |
| Math Symbol | 3164 | 0.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1437965 | |
| 2 | 45378 | 2.8% |
| 5 | 28748 | 1.8% |
| 1 | 26663 | 1.6% |
| 9 | 22196 | 1.4% |
| 3 | 18165 | 1.1% |
| 8 | 14580 | 0.9% |
| 4 | 12336 | 0.8% |
| 7 | 12132 | 0.7% |
| 6 | 10668 | 0.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| X | 124296 | |
| E | 3164 | 2.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 3164 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 3164 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1635159 | |
| Latin | 127460 | 7.2% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1437965 | |
| 2 | 45378 | 2.8% |
| 5 | 28748 | 1.8% |
| 1 | 26663 | 1.6% |
| 9 | 22196 | 1.4% |
| 3 | 18165 | 1.1% |
| 8 | 14580 | 0.9% |
| 4 | 12336 | 0.8% |
| 7 | 12132 | 0.7% |
| 6 | 10668 | 0.7% |
| Other values (2) | 6328 | 0.4% |
Latin
| Value | Count | Frequency (%) |
| X | 124296 | |
| E | 3164 | 2.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1762619 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1437965 | |
| X | 124296 | 7.1% |
| 2 | 45378 | 2.6% |
| 5 | 28748 | 1.6% |
| 1 | 26663 | 1.5% |
| 9 | 22196 | 1.3% |
| 3 | 18165 | 1.0% |
| 8 | 14580 | 0.8% |
| 4 | 12336 | 0.7% |
| 7 | 12132 | 0.7% |
| Other values (4) | 20160 | 1.1% |
MISSING
| Distinct | 616 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 39673 |
| Missing (%) | 56.7% |
| Memory size | 546.7 KiB |
Length
| Max length | 54 |
|---|---|
| Median length | 1 |
| Mean length | 4.5951461 |
| Min length | 1 |
Characters and Unicode
| Total characters | 139164 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 356 ? |
|---|---|
| Unique (%) | 1.2% |
Sample
| 1st row | 3.00E+19 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 4.50E+53 |
| 5th row | 1.80E+53 |
| Value | Count | Frequency (%) |
| 0 | 21172 | |
| 3.00e+52 | 1369 | 4.5% |
| 9.01e+53 | 786 | 2.6% |
| 6.01e+52 | 677 | 2.2% |
| 9.01e+52 | 420 | 1.4% |
| 3.00e+16 | 214 | 0.7% |
| 3.00e+49 | 184 | 0.6% |
| 1.20e+53 | 171 | 0.6% |
| 3.00e+43 | 157 | 0.5% |
| 6.00e+52 | 155 | 0.5% |
| Other values (606) | 4980 | 16.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 66158 | |
| X | 23067 | 16.6% |
| . | 7206 | 5.2% |
| E | 7206 | 5.2% |
| + | 7206 | 5.2% |
| 3 | 6956 | 5.0% |
| 5 | 5591 | 4.0% |
| 2 | 4409 | 3.2% |
| 1 | 4406 | 3.2% |
| 6 | 2351 | 1.7% |
| Other values (4) | 4608 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 94479 | |
| Uppercase Letter | 30273 | 21.8% |
| Other Punctuation | 7206 | 5.2% |
| Math Symbol | 7206 | 5.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 66158 | |
| 3 | 6956 | 7.4% |
| 5 | 5591 | 5.9% |
| 2 | 4409 | 4.7% |
| 1 | 4406 | 4.7% |
| 6 | 2351 | 2.5% |
| 9 | 2078 | 2.2% |
| 4 | 1560 | 1.7% |
| 8 | 569 | 0.6% |
| 7 | 401 | 0.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| X | 23067 | |
| E | 7206 | 23.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 7206 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 7206 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 108891 | |
| Latin | 30273 | 21.8% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 66158 | |
| . | 7206 | 6.6% |
| + | 7206 | 6.6% |
| 3 | 6956 | 6.4% |
| 5 | 5591 | 5.1% |
| 2 | 4409 | 4.0% |
| 1 | 4406 | 4.0% |
| 6 | 2351 | 2.2% |
| 9 | 2078 | 1.9% |
| 4 | 1560 | 1.4% |
| Other values (2) | 970 | 0.9% |
Latin
| Value | Count | Frequency (%) |
| X | 23067 | |
| E | 7206 | 23.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 139164 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 66158 | |
| X | 23067 | 16.6% |
| . | 7206 | 5.2% |
| E | 7206 | 5.2% |
| + | 7206 | 5.2% |
| 3 | 6956 | 5.0% |
| 5 | 5591 | 4.0% |
| 2 | 4409 | 3.2% |
| 1 | 4406 | 3.2% |
| 6 | 2351 | 1.7% |
| Other values (4) | 4608 | 3.3% |
OWNERSHIP_TYPE
Categorical
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
| Joint | |
|---|---|
| Individual |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 6.2452471 |
| Min length | 5 |
Characters and Unicode
| Total characters | 436905 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Joint |
|---|---|
| 2nd row | Joint |
| 3rd row | Joint |
| 4th row | Joint |
| 5th row | Joint |
Common Values
| Value | Count | Frequency (%) |
| Joint | 52535 | |
| Individual | 17423 | 24.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| joint | 52535 | |
| individual | 17423 | 24.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 87381 | |
| n | 69958 | |
| J | 52535 | |
| o | 52535 | |
| t | 52535 | |
| d | 34846 | 8.0% |
| I | 17423 | 4.0% |
| v | 17423 | 4.0% |
| u | 17423 | 4.0% |
| a | 17423 | 4.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 366947 | |
| Uppercase Letter | 69958 | 16.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 87381 | |
| n | 69958 | |
| o | 52535 | |
| t | 52535 | |
| d | 34846 | 9.5% |
| v | 17423 | 4.7% |
| u | 17423 | 4.7% |
| a | 17423 | 4.7% |
| l | 17423 | 4.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 52535 | |
| I | 17423 | 24.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 436905 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 87381 | |
| n | 69958 | |
| J | 52535 | |
| o | 52535 | |
| t | 52535 | |
| d | 34846 | 8.0% |
| I | 17423 | 4.0% |
| v | 17423 | 4.0% |
| u | 17423 | 4.0% |
| a | 17423 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 436905 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 87381 | |
| n | 69958 | |
| J | 52535 | |
| o | 52535 | |
| t | 52535 | |
| d | 34846 | 8.0% |
| I | 17423 | 4.0% |
| v | 17423 | 4.0% |
| u | 17423 | 4.0% |
| a | 17423 | 4.0% |
COLLATERALVALUE
Real number (ℝ)
HIGH CORRELATION MISSING SKEWED
| Distinct | 27826 |
|---|---|
| Distinct (%) | 59.2% |
| Missing | 22968 |
| Missing (%) | 32.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3586770.9 |
| Minimum | 1 |
|---|---|
| Maximum | 7.26147 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 546.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 900000 |
| Q1 | 1560000 |
| median | 2327047 |
| Q3 | 3697500 |
| 95-th percentile | 9186928 |
| Maximum | 7.26147 × 108 |
| Range | 7.26147 × 108 |
| Interquartile range (IQR) | 2137500 |
Descriptive statistics
| Standard deviation | 7908637.5 |
|---|---|
| Coefficient of variation (CV) | 2.2049464 |
| Kurtosis | 2635.6579 |
| Mean | 3586770.9 |
| Median Absolute Deviation (MAD) | 925557 |
| Skewness | 39.330653 |
| Sum | 1.6854236 × 1011 |
| Variance | 6.2546547 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1800000 | 250 | 0.4% |
| 1500000 | 238 | 0.3% |
| 1200000 | 236 | 0.3% |
| 2000000 | 196 | 0.3% |
| 3000000 | 159 | 0.2% |
| 1400000 | 157 | 0.2% |
| 900000 | 145 | 0.2% |
| 1000000 | 145 | 0.2% |
| 1300000 | 144 | 0.2% |
| 1600000 | 143 | 0.2% |
| Other values (27816) | 45177 | |
| (Missing) | 22968 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 42000 | 1 | |
| 50000 | 1 | |
| 126000 | 1 | |
| 142694 | 1 | |
| 150350 | 1 | |
| 165256 | 1 | |
| 180950 | 1 | |
| 193680 | 1 | |
| 200000 | 2 |
| Value | Count | Frequency (%) |
| 726147000 | 1 | |
| 544527618 | 1 | |
| 503958000 | 1 | |
| 379341298 | 1 | |
| 368579500 | 1 | |
| 280002020 | 1 | |
| 260357600 | 1 | |
| 253882000 | 1 | |
| 240451200 | 1 | |
| 191787218 | 1 |
TU_SCORE
Real number (ℝ)
HIGH CORRELATION
| Distinct | 284 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 739.75801 |
| Minimum | 533 |
|---|---|
| Maximum | 851 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 546.7 KiB |
Quantile statistics
| Minimum | 533 |
|---|---|
| 5-th percentile | 639 |
| Q1 | 717 |
| median | 753 |
| Q3 | 774 |
| 95-th percentile | 798 |
| Maximum | 851 |
| Range | 318 |
| Interquartile range (IQR) | 57 |
Descriptive statistics
| Standard deviation | 49.101644 |
|---|---|
| Coefficient of variation (CV) | 0.066375279 |
| Kurtosis | 1.1869819 |
| Mean | 739.75801 |
| Median Absolute Deviation (MAD) | 25 |
| Skewness | -1.1953222 |
| Sum | 51751991 |
| Variance | 2410.9715 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 746 | 2374 | 3.4% |
| 780 | 2373 | 3.4% |
| 757 | 1713 | 2.4% |
| 774 | 1568 | 2.2% |
| 778 | 1210 | 1.7% |
| 771 | 1163 | 1.7% |
| 769 | 1023 | 1.5% |
| 786 | 989 | 1.4% |
| 776 | 965 | 1.4% |
| 777 | 905 | 1.3% |
| Other values (274) | 55675 |
| Value | Count | Frequency (%) |
| 533 | 2 | < 0.1% |
| 537 | 1 | < 0.1% |
| 538 | 1 | < 0.1% |
| 544 | 2 | < 0.1% |
| 546 | 4 | < 0.1% |
| 548 | 2 | < 0.1% |
| 555 | 17 | |
| 559 | 5 | < 0.1% |
| 560 | 8 | |
| 562 | 12 |
| Value | Count | Frequency (%) |
| 851 | 1 | < 0.1% |
| 843 | 2 | < 0.1% |
| 840 | 2 | < 0.1% |
| 839 | 1 | < 0.1% |
| 838 | 7 | |
| 837 | 3 | |
| 836 | 1 | < 0.1% |
| 835 | 2 | < 0.1% |
| 834 | 5 | |
| 833 | 5 |
PAYMENT_HISTORY_START_DATE
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
| 01-11-2023 | |
|---|---|
| 01-12-2023 | 2 |
| 01-01-2024 | 1 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 699580 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 01-11-2023 |
|---|---|
| 2nd row | 01-11-2023 |
| 3rd row | 01-11-2023 |
| 4th row | 01-11-2023 |
| 5th row | 01-11-2023 |
Common Values
| Value | Count | Frequency (%) |
| 01-11-2023 | 69955 | |
| 01-12-2023 | 2 | < 0.1% |
| 01-01-2024 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 01-11-2023 | 69955 | |
| 01-12-2023 | 2 | < 0.1% |
| 01-01-2024 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 209871 | |
| 2 | 139918 | |
| 0 | 139917 | |
| - | 139916 | |
| 3 | 69957 | 10.0% |
| 4 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 559664 | |
| Dash Punctuation | 139916 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 209871 | |
| 2 | 139918 | |
| 0 | 139917 | |
| 3 | 69957 | 12.5% |
| 4 | 1 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 139916 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 699580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 209871 | |
| 2 | 139918 | |
| 0 | 139917 | |
| - | 139916 | |
| 3 | 69957 | 10.0% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 699580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 209871 | |
| 2 | 139918 | |
| 0 | 139917 | |
| - | 139916 | |
| 3 | 69957 | 10.0% |
| 4 | 1 | < 0.1% |
PAYMENT_HISTORY_END_DATE
Categorical
HIGH CORRELATION
| Distinct | 34 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
| 01-12-2020 | |
|---|---|
| 01-10-2023 | |
| 01-11-2023 | |
| 01-09-2023 | |
| 01-07-2023 | |
| Other values (29) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 699580 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 01-12-2020 |
|---|---|
| 2nd row | 01-12-2020 |
| 3rd row | 01-12-2020 |
| 4th row | 01-12-2022 |
| 5th row | 01-12-2020 |
Common Values
| Value | Count | Frequency (%) |
| 01-12-2020 | 26781 | |
| 01-10-2023 | 5060 | 7.2% |
| 01-11-2023 | 3431 | 4.9% |
| 01-09-2023 | 3261 | 4.7% |
| 01-07-2023 | 2865 | 4.1% |
| 01-03-2023 | 2759 | 3.9% |
| 01-08-2023 | 2592 | 3.7% |
| 01-08-2022 | 2567 | 3.7% |
| 01-12-2022 | 2318 | 3.3% |
| 01-04-2023 | 2256 | 3.2% |
| Other values (24) | 16068 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 01-12-2020 | 26781 | |
| 01-10-2023 | 5060 | 7.2% |
| 01-11-2023 | 3431 | 4.9% |
| 01-09-2023 | 3261 | 4.7% |
| 01-07-2023 | 2865 | 4.1% |
| 01-03-2023 | 2759 | 3.9% |
| 01-08-2023 | 2592 | 3.7% |
| 01-08-2022 | 2567 | 3.7% |
| 01-12-2022 | 2318 | 3.3% |
| 01-04-2023 | 2256 | 3.2% |
| Other values (24) | 16068 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 202801 | |
| 2 | 182733 | |
| - | 139916 | |
| 1 | 118281 | |
| 3 | 34768 | 5.0% |
| 8 | 5258 | 0.8% |
| 9 | 5059 | 0.7% |
| 7 | 2987 | 0.4% |
| 5 | 2832 | 0.4% |
| 4 | 2744 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 559664 | |
| Dash Punctuation | 139916 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 202801 | |
| 2 | 182733 | |
| 1 | 118281 | |
| 3 | 34768 | 6.2% |
| 8 | 5258 | 0.9% |
| 9 | 5059 | 0.9% |
| 7 | 2987 | 0.5% |
| 5 | 2832 | 0.5% |
| 4 | 2744 | 0.5% |
| 6 | 2201 | 0.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 139916 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 699580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 202801 | |
| 2 | 182733 | |
| - | 139916 | |
| 1 | 118281 | |
| 3 | 34768 | 5.0% |
| 8 | 5258 | 0.8% |
| 9 | 5059 | 0.7% |
| 7 | 2987 | 0.4% |
| 5 | 2832 | 0.4% |
| 4 | 2744 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 699580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 202801 | |
| 2 | 182733 | |
| - | 139916 | |
| 1 | 118281 | |
| 3 | 34768 | 5.0% |
| 8 | 5258 | 0.8% |
| 9 | 5059 | 0.7% |
| 7 | 2987 | 0.4% |
| 5 | 2832 | 0.4% |
| 4 | 2744 | 0.4% |
DATE_REPORTED_AND_CERTIFIED
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
| 30-11-2023 | |
|---|---|
| 05-12-2023 | 2 |
| 02-01-2024 | 1 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 699580 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 30-11-2023 |
|---|---|
| 2nd row | 30-11-2023 |
| 3rd row | 30-11-2023 |
| 4th row | 30-11-2023 |
| 5th row | 30-11-2023 |
Common Values
| Value | Count | Frequency (%) |
| 30-11-2023 | 69955 | |
| 05-12-2023 | 2 | < 0.1% |
| 02-01-2024 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 30-11-2023 | 69955 | |
| 05-12-2023 | 2 | < 0.1% |
| 02-01-2024 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 139919 | |
| 0 | 139917 | |
| - | 139916 | |
| 1 | 139913 | |
| 3 | 139912 | |
| 5 | 2 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 559664 | |
| Dash Punctuation | 139916 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 139919 | |
| 0 | 139917 | |
| 1 | 139913 | |
| 3 | 139912 | |
| 5 | 2 | < 0.1% |
| 4 | 1 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 139916 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 699580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 139919 | |
| 0 | 139917 | |
| - | 139916 | |
| 1 | 139913 | |
| 3 | 139912 | |
| 5 | 2 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 699580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 139919 | |
| 0 | 139917 | |
| - | 139916 | |
| 1 | 139913 | |
| 3 | 139912 | |
| 5 | 2 | < 0.1% |
| 4 | 1 | < 0.1% |
MISSING
| Distinct | 468 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 3312 |
| Missing (%) | 4.7% |
| Memory size | 546.7 KiB |
| Minimum | 2009-01-15 00:00:00 |
|---|---|
| Maximum | 2023-12-28 00:00:00 |
Histogram with fixed size bins (bins=50)
Reported_Date
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
| 30-11-2023 | |
|---|---|
| 05-12-2023 | 2 |
| 02-01-2024 | 1 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 699580 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 30-11-2023 |
|---|---|
| 2nd row | 30-11-2023 |
| 3rd row | 30-11-2023 |
| 4th row | 30-11-2023 |
| 5th row | 30-11-2023 |
Common Values
| Value | Count | Frequency (%) |
| 30-11-2023 | 69955 | |
| 05-12-2023 | 2 | < 0.1% |
| 02-01-2024 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 30-11-2023 | 69955 | |
| 05-12-2023 | 2 | < 0.1% |
| 02-01-2024 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 139919 | |
| 0 | 139917 | |
| - | 139916 | |
| 1 | 139913 | |
| 3 | 139912 | |
| 5 | 2 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 559664 | |
| Dash Punctuation | 139916 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 139919 | |
| 0 | 139917 | |
| 1 | 139913 | |
| 3 | 139912 | |
| 5 | 2 | < 0.1% |
| 4 | 1 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 139916 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 699580 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 139919 | |
| 0 | 139917 | |
| - | 139916 | |
| 1 | 139913 | |
| 3 | 139912 | |
| 5 | 2 | < 0.1% |
| 4 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 699580 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 139919 | |
| 0 | 139917 | |
| - | 139916 | |
| 1 | 139913 | |
| 3 | 139912 | |
| 5 | 2 | < 0.1% |
| 4 | 1 | < 0.1% |
DATE_OF_BIRTH
Date
| Distinct | 15335 |
|---|---|
| Distinct (%) | 21.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
| Minimum | 1927-04-24 00:00:00 |
|---|---|
| Maximum | 2005-11-02 00:00:00 |
Histogram with fixed size bins (bins=50)
OCCUPATION_TYPE
Categorical
HIGH CORRELATION MISSING
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 19113 |
| Missing (%) | 27.3% |
| Memory size | 546.7 KiB |
| SALARIED | |
|---|---|
| SENP | |
| OTHERS | |
| SEP | |
| R18 | 1 |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 6.366388 |
| Min length | 3 |
Characters and Unicode
| Total characters | 323699 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SALARIED |
|---|---|
| 2nd row | SALARIED |
| 3rd row | SALARIED |
| 4th row | SALARIED |
| 5th row | SALARIED |
Common Values
| Value | Count | Frequency (%) |
| SALARIED | 28677 | |
| SENP | 11963 | |
| OTHERS | 5272 | 7.5% |
| SEP | 4932 | 7.0% |
| R18 | 1 | < 0.1% |
| (Missing) | 19113 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| salaried | 28677 | |
| senp | 11963 | |
| others | 5272 | 10.4% |
| sep | 4932 | 9.7% |
| r18 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 57354 | |
| S | 50844 | |
| E | 50844 | |
| R | 33950 | |
| L | 28677 | |
| I | 28677 | |
| D | 28677 | |
| P | 16895 | 5.2% |
| N | 11963 | 3.7% |
| O | 5272 | 1.6% |
| Other values (4) | 10546 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 323697 | |
| Decimal Number | 2 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 57354 | |
| S | 50844 | |
| E | 50844 | |
| R | 33950 | |
| L | 28677 | |
| I | 28677 | |
| D | 28677 | |
| P | 16895 | 5.2% |
| N | 11963 | 3.7% |
| O | 5272 | 1.6% |
| Other values (2) | 10544 | 3.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 8 | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 323697 | |
| Common | 2 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 57354 | |
| S | 50844 | |
| E | 50844 | |
| R | 33950 | |
| L | 28677 | |
| I | 28677 | |
| D | 28677 | |
| P | 16895 | 5.2% |
| N | 11963 | 3.7% |
| O | 5272 | 1.6% |
| Other values (2) | 10544 | 3.3% |
Common
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 8 | 1 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 323699 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 57354 | |
| S | 50844 | |
| E | 50844 | |
| R | 33950 | |
| L | 28677 | |
| I | 28677 | |
| D | 28677 | |
| P | 16895 | 5.2% |
| N | 11963 | 3.7% |
| O | 5272 | 1.6% |
| Other values (4) | 10546 | 3.3% |
GENDER
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 546.7 KiB |
| Male | |
|---|---|
| Female | |
| Other | 59 |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.6453729 |
| Min length | 4 |
Characters and Unicode
| Total characters | 324981 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Male |
|---|---|
| 2nd row | Female |
| 3rd row | Male |
| 4th row | Female |
| 5th row | Male |
Common Values
| Value | Count | Frequency (%) |
| Male | 47354 | |
| Female | 22545 | |
| Other | 59 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| male | 47354 | |
| female | 22545 | |
| other | 59 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 92503 | |
| a | 69899 | |
| l | 69899 | |
| M | 47354 | |
| F | 22545 | 6.9% |
| m | 22545 | 6.9% |
| O | 59 | < 0.1% |
| t | 59 | < 0.1% |
| h | 59 | < 0.1% |
| r | 59 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 255023 | |
| Uppercase Letter | 69958 | 21.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 92503 | |
| a | 69899 | |
| l | 69899 | |
| m | 22545 | 8.8% |
| t | 59 | < 0.1% |
| h | 59 | < 0.1% |
| r | 59 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 47354 | |
| F | 22545 | |
| O | 59 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 324981 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 92503 | |
| a | 69899 | |
| l | 69899 | |
| M | 47354 | |
| F | 22545 | 6.9% |
| m | 22545 | 6.9% |
| O | 59 | < 0.1% |
| t | 59 | < 0.1% |
| h | 59 | < 0.1% |
| r | 59 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 324981 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 92503 | |
| a | 69899 | |
| l | 69899 | |
| M | 47354 | |
| F | 22545 | 6.9% |
| m | 22545 | 6.9% |
| O | 59 | < 0.1% |
| t | 59 | < 0.1% |
| h | 59 | < 0.1% |
| r | 59 | < 0.1% |
ACTUAL_ROI
Real number (ℝ)
HIGH CORRELATION
| Distinct | 794 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.010569 |
| Minimum | 0 |
|---|---|
| Maximum | 45 |
| Zeros | 7 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 546.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 11.25 |
| median | 13.35 |
| Q3 | 18 |
| 95-th percentile | 34 |
| Maximum | 45 |
| Range | 45 |
| Interquartile range (IQR) | 6.75 |
Descriptive statistics
| Standard deviation | 6.9835257 |
|---|---|
| Coefficient of variation (CV) | 0.43618222 |
| Kurtosis | 1.7186182 |
| Mean | 16.010569 |
| Median Absolute Deviation (MAD) | 2.38 |
| Skewness | 1.6127186 |
| Sum | 1120067.4 |
| Variance | 48.769631 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10.5 | 2076 | 3.0% |
| 10 | 1964 | 2.8% |
| 10.92 | 1930 | 2.8% |
| 13.8 | 1768 | 2.5% |
| 36 | 1494 | 2.1% |
| 11.22 | 1435 | 2.1% |
| 13.5 | 1351 | 1.9% |
| 35 | 1232 | 1.8% |
| 13 | 1143 | 1.6% |
| 20 | 1050 | 1.5% |
| Other values (784) | 54515 |
| Value | Count | Frequency (%) |
| 0 | 7 | |
| 7.5 | 4 | < 0.1% |
| 7.75 | 5 | |
| 8 | 1 | < 0.1% |
| 8.25 | 3 | < 0.1% |
| 8.3 | 1 | < 0.1% |
| 8.5 | 12 | |
| 8.6 | 1 | < 0.1% |
| 8.62 | 5 | |
| 8.65 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 45 | 1 | < 0.1% |
| 44.25 | 6 | |
| 44 | 1 | < 0.1% |
| 43.9 | 1 | < 0.1% |
| 43.6 | 1 | < 0.1% |
| 43.54 | 1 | < 0.1% |
| 43 | 1 | < 0.1% |
| 42.9 | 11 | |
| 42.6 | 1 | < 0.1% |
| 42.58 | 1 | < 0.1% |
| ACCOUNT_TYPE | ACTUAL_PAYMT_AMT | ACTUAL_ROI | AMOUNT_OVERDUE | COLLATERALVALUE | CURRENT_BALANCE | DATE_REPORTED_AND_CERTIFIED | EMI_AMOUNT | GENDER | HIGH_CREDIT_OR_SANCTIONED_AMOUNT | LOAN_CLASSIFICATION | OCCUPATION_TYPE | OWNERSHIP_TYPE | PAYMENT_HISTORY_END_DATE | PAYMENT_HISTORY_START_DATE | REPAYMENT_TENURE | Reported_Date | TU_SCORE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACCOUNT_TYPE | 1.000 | -0.159 | 0.255 | -0.219 | 0.214 | -0.170 | 0.009 | -0.195 | 0.154 | -0.183 | -0.011 | 0.351 | 0.935 | 0.403 | 0.009 | -0.031 | 0.009 | -0.025 |
| ACTUAL_PAYMT_AMT | -0.159 | 1.000 | -0.237 | 0.522 | 0.547 | 0.614 | 0.000 | 0.787 | 0.000 | 0.606 | -0.015 | 0.000 | 0.000 | 0.000 | 0.000 | 0.032 | 0.000 | 0.054 |
| ACTUAL_ROI | 0.255 | -0.237 | 1.000 | -0.269 | -0.086 | -0.569 | 0.000 | -0.325 | 0.118 | -0.627 | 0.037 | 0.236 | 0.710 | 0.198 | 0.000 | -0.176 | 0.000 | -0.253 |
| AMOUNT_OVERDUE | -0.219 | 0.522 | -0.269 | 1.000 | 0.410 | 0.644 | 0.000 | 0.679 | 0.000 | 0.626 | 0.804 | 0.000 | 0.002 | 0.000 | 0.000 | 0.057 | 0.000 | -0.489 |
| COLLATERALVALUE | 0.214 | 0.547 | -0.086 | 0.410 | 1.000 | 0.696 | 0.000 | 0.714 | 0.000 | 0.762 | -0.005 | 0.015 | 0.046 | 0.000 | 0.000 | 0.079 | 0.000 | -0.033 |
| CURRENT_BALANCE | -0.170 | 0.614 | -0.569 | 0.644 | 0.696 | 1.000 | 0.000 | 0.803 | 0.000 | 0.937 | 0.067 | 0.006 | 0.007 | 0.000 | 0.000 | 0.550 | 0.000 | 0.040 |
| DATE_REPORTED_AND_CERTIFIED | 0.009 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | -0.014 | 0.000 | -0.004 | -0.003 | 1.000 | 0.000 | 0.081 | 1.000 | 0.014 | 1.000 | 0.009 |
| EMI_AMOUNT | -0.195 | 0.787 | -0.325 | 0.679 | 0.714 | 0.803 | -0.014 | 1.000 | 0.000 | 0.813 | 0.018 | 0.009 | 0.018 | 0.000 | 0.000 | 0.067 | 0.000 | 0.022 |
| GENDER | 0.154 | 0.000 | 0.118 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | -0.178 | 0.032 | 0.273 | 0.216 | 0.074 | 0.000 | -0.003 | 0.000 | -0.108 |
| HIGH_CREDIT_OR_SANCTIONED_AMOUNT | -0.183 | 0.606 | -0.627 | 0.626 | 0.762 | 0.937 | -0.004 | 0.813 | -0.178 | 1.000 | 0.061 | 0.007 | 0.007 | 0.000 | 0.000 | 0.289 | 0.000 | 0.077 |
| LOAN_CLASSIFICATION | -0.011 | -0.015 | 0.037 | 0.804 | -0.005 | 0.067 | -0.003 | 0.018 | 0.032 | 0.061 | 1.000 | 0.082 | 0.086 | 0.078 | 0.000 | 0.136 | 0.000 | -0.515 |
| OCCUPATION_TYPE | 0.351 | 0.000 | 0.236 | 0.000 | 0.015 | 0.006 | 1.000 | 0.009 | 0.273 | 0.007 | 0.082 | 1.000 | 0.537 | 0.239 | 1.000 | 0.159 | 1.000 | -0.128 |
| OWNERSHIP_TYPE | 0.935 | 0.000 | 0.710 | 0.002 | 0.046 | 0.007 | 0.000 | 0.018 | 0.216 | 0.007 | 0.086 | 0.537 | 1.000 | 0.503 | 0.000 | 0.057 | 0.000 | 0.118 |
| PAYMENT_HISTORY_END_DATE | 0.403 | 0.000 | 0.198 | 0.000 | 0.000 | 0.000 | 0.081 | 0.000 | 0.074 | 0.000 | 0.078 | 0.239 | 0.503 | 1.000 | 0.081 | 0.037 | 0.081 | 0.029 |
| PAYMENT_HISTORY_START_DATE | 0.009 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.081 | 1.000 | -0.004 | 1.000 | -0.003 |
| REPAYMENT_TENURE | -0.031 | 0.032 | -0.176 | 0.057 | 0.079 | 0.550 | 0.014 | 0.067 | -0.003 | 0.289 | 0.136 | 0.159 | 0.057 | 0.037 | -0.004 | 1.000 | 0.000 | -0.145 |
| Reported_Date | 0.009 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.081 | 1.000 | 0.000 | 1.000 | 0.009 |
| TU_SCORE | -0.025 | 0.054 | -0.253 | -0.489 | -0.033 | 0.040 | 0.009 | 0.022 | -0.108 | 0.077 | -0.515 | -0.128 | 0.118 | 0.029 | -0.003 | -0.145 | 0.009 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| ID | ACCOUNT_TYPE | HIGH_CREDIT_OR_SANCTIONED_AMOUNT | DATE_OPENED | CURRENT_BALANCE | ACTUAL_PAYMT_AMT | EMI_AMOUNT | REPAYMENT_TENURE | LOAN_CLASSIFICATION | AMOUNT_OVERDUE | PAYMENT_HISTORY_1 | PAYMENT_HISTORY_2 | OWNERSHIP_TYPE | COLLATERALVALUE | TU_SCORE | PAYMENT_HISTORY_START_DATE | PAYMENT_HISTORY_END_DATE | DATE_REPORTED_AND_CERTIFIED | DATE_OF_LAST_PAYMENT | Reported_Date | DATE_OF_BIRTH | OCCUPATION_TYPE | GENDER | ACTUAL_ROI | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | A002338349 | Housing Loan | 818517 | 13-06-2014 | 640742 | 8627.0 | 8627.0 | 142.0 | 0 | NaN | 000000000000000000000000000000000000052052052021XXX000 | 3.00E+19 | Joint | 2086000.0 | 681 | 01-11-2023 | 01-12-2020 | 30-11-2023 | 30-11-2023 | 30-11-2023 | 21-05-1971 | SALARIED | Male | 12.32 |
| 1 | A002000537 | Housing Loan | 1243755 | 05-12-2012 | 949446 | 500.0 | 12210.0 | 156.0 | 0 | NaN | 000000000000000000000000000000000000000000000000XXX000 | 0 | Joint | 1536000.0 | 784 | 01-11-2023 | 01-12-2020 | 30-11-2023 | 30-11-2023 | 30-11-2023 | 12-11-1984 | SALARIED | Female | 12.42 |
| 2 | A002421579 | Housing Loan | 1826422 | 16-03-2017 | 1296849 | 16036.0 | 16036.0 | 148.0 | 0 | NaN | 000000000000000000000000000000000000000000000000XXX000 | 0 | Joint | 3587700.0 | 748 | 01-11-2023 | 01-12-2020 | 30-11-2023 | 11-11-2023 | 30-11-2023 | 01-08-1986 | SALARIED | Male | 10.87 |
| 3 | A002152345 | Housing Loan | 1847916 | 24-12-2022 | 1724256 | 26996.0 | NaN | NaN | 0 | NaN | 0 | NaN | Joint | 3049600.0 | 786 | 01-11-2023 | 01-12-2022 | 30-11-2023 | 05-11-2023 | 30-11-2023 | 22-07-1969 | NaN | Female | 10.00 |
| 4 | A001952834 | Housing Loan | 2318386 | 21-10-2014 | 1790937 | 25131.0 | NaN | 116.0 | 539 | 431551.0 | 539570570540509506507507507507509509509479478478XXX450 | 4.50E+53 | Joint | 2785400.0 | 664 | 01-11-2023 | 01-12-2020 | 30-11-2023 | 27-11-2023 | 30-11-2023 | 28-10-1974 | SALARIED | Male | 11.97 |
| 5 | A002239370 | Property Loan | 1163870 | 21-04-2017 | 959370 | 12544.0 | NaN | 158.0 | 21 | 12533.0 | 021022052053052052052052050050000000000000000264XXX210 | 1.80E+53 | Joint | 2369812.0 | 710 | 01-11-2023 | 01-12-2020 | 30-11-2023 | 30-11-2023 | 30-11-2023 | 28-10-1966 | SALARIED | Male | 12.97 |
| 6 | A000936177 | Housing Loan | 2400318 | 01-03-2023 | 2385404 | 500.0 | NaN | NaN | 0 | NaN | 0 | NaN | Joint | 3068676.0 | 774 | 01-11-2023 | 01-03-2023 | 30-11-2023 | 15-11-2023 | 30-11-2023 | 05-05-1990 | NaN | Male | 14.25 |
| 7 | A001137499 | Personal Loan | 138000 | 26-02-2023 | 96869 | 6756.0 | 6756.0 | NaN | 0 | NaN | 0 | NaN | Individual | NaN | 714 | 01-11-2023 | 01-02-2023 | 30-11-2023 | 05-11-2023 | 30-11-2023 | 07-09-1987 | SALARIED | Male | 15.99 |
| 8 | A002421104 | Housing Loan | 1436063 | 12-01-2015 | 1302519 | NaN | 17247.0 | 97.0 | 900 | 1223863.0 | 900900900900900900900900900900900900900900900900XXX900 | 9.01E+53 | Joint | 1844612.0 | 599 | 01-11-2023 | 01-12-2020 | 30-11-2023 | 01-07-2022 | 30-11-2023 | 15-07-1982 | SENP | Male | 13.82 |
| 9 | A001132923 | Housing Loan | 889992 | 27-07-2021 | 604148 | 7421.0 | 7420.0 | 240.0 | 0 | NaN | 000000000000000000000000000000000000000000000000XXXXXX | 000000000XXXXXX000000000000000000 | Joint | 1176000.0 | 772 | 01-11-2023 | 01-07-2021 | 30-11-2023 | 05-11-2023 | 30-11-2023 | 01-01-1987 | NaN | Male | 14.50 |
| ID | ACCOUNT_TYPE | HIGH_CREDIT_OR_SANCTIONED_AMOUNT | DATE_OPENED | CURRENT_BALANCE | ACTUAL_PAYMT_AMT | EMI_AMOUNT | REPAYMENT_TENURE | LOAN_CLASSIFICATION | AMOUNT_OVERDUE | PAYMENT_HISTORY_1 | PAYMENT_HISTORY_2 | OWNERSHIP_TYPE | COLLATERALVALUE | TU_SCORE | PAYMENT_HISTORY_START_DATE | PAYMENT_HISTORY_END_DATE | DATE_REPORTED_AND_CERTIFIED | DATE_OF_LAST_PAYMENT | Reported_Date | DATE_OF_BIRTH | OCCUPATION_TYPE | GENDER | ACTUAL_ROI | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69948 | A001905850 | Housing Loan | 1882849 | 27-08-2022 | 1872477 | 20505.0 | NaN | 240.0 | 0 | NaN | 0 | NaN | Joint | 3055400.0 | 774 | 01-11-2023 | 01-08-2022 | 30-11-2023 | 05-11-2023 | 30-11-2023 | 11-05-1991 | NaN | Female | 11.50 |
| 69949 | A001397677 | Housing Loan | 669506 | 15-02-2018 | 198517 | 4866.0 | NaN | 67.0 | 0 | NaN | 000000000000000000000000000000000000000000000000XXX000 | 0 | Joint | 1881424.0 | 780 | 01-11-2023 | 01-12-2020 | 30-11-2023 | 12-11-2023 | 30-11-2023 | 15-04-1950 | SENP | Male | 11.47 |
| 69950 | B000198178 | Personal Loan | 504000 | 14-09-2023 | 483828 | 14755.0 | NaN | NaN | 0 | NaN | 0 | NaN | Individual | NaN | 771 | 01-11-2023 | 01-09-2023 | 30-11-2023 | 10-11-2023 | 30-11-2023 | 15-05-1996 | SALARIED | Male | 12.00 |
| 69951 | A001175214 | Business Loan | 691132 | 10-10-2022 | 563752 | 21042.0 | 20665.0 | NaN | 0 | NaN | 000000000000000000000000000000000000XXX000 | NaN | Joint | NaN | 706 | 01-11-2023 | 01-10-2022 | 30-11-2023 | 05-11-2023 | 30-11-2023 | 01-01-1964 | NaN | Female | 19.00 |
| 69952 | B000092060 | Personal Loan | 7000 | 05-10-2023 | 5330 | 1884.0 | 1884.0 | NaN | 0 | NaN | 0 | NaN | Individual | NaN | 734 | 01-11-2023 | 01-10-2023 | 30-11-2023 | 30-11-2023 | 30-11-2023 | 18-05-1996 | SEP | Female | 36.00 |
| 69953 | A000195582 | Property Loan | 2600000 | 15-03-2018 | 2381437 | 30762.0 | 30762.0 | 162.0 | 21 | 30762.0 | 021000000000000000000000000000000000000000000000XXX000 | 0 | Joint | 16335000.0 | 744 | 01-11-2023 | 01-12-2020 | 30-11-2023 | 01-11-2023 | 30-11-2023 | 05-02-1989 | SENP | Female | 12.97 |
| 69954 | A001735798 | Business Loan | 1016188 | 26-08-2022 | 790486 | 29851.0 | NaN | 48.0 | 0 | NaN | 0 | NaN | Joint | NaN | 673 | 01-11-2023 | 01-08-2022 | 30-11-2023 | 05-11-2023 | 30-11-2023 | 22-08-1992 | NaN | Male | 18.00 |
| 69955 | A002435973 | Business Loan | 335475 | 22-03-2022 | 281106 | 10388.0 | NaN | 48.0 | 240 | 82468.0 | 240210179149118087116085055024000000000000000000XXXXXX | 0 | Joint | NaN | 567 | 01-11-2023 | 01-03-2022 | 30-11-2023 | 19-06-2023 | 30-11-2023 | 13-05-1987 | NaN | Male | 21.00 |
| 69956 | A000027755 | Housing Loan | 1585160 | 12-09-2015 | 1255235 | 16739.0 | NaN | 143.0 | 0 | NaN | 000000000000000000000000000000000000000000000000XXX000 | 0 | Joint | 9506700.0 | 798 | 01-11-2023 | 01-12-2020 | 30-11-2023 | 14-11-2023 | 30-11-2023 | 01-06-1971 | SALARIED | Male | 12.07 |
| 69957 | A000500401 | Housing Loan | 542973 | 17-06-2023 | 357217 | 2878.0 | NaN | NaN | 0 | NaN | 0 | NaN | Joint | 1781027.0 | 757 | 01-11-2023 | 01-06-2023 | 30-11-2023 | 05-11-2023 | 30-11-2023 | 03-02-1989 | OTHERS | Female | 12.85 |